# coding: utf-8
from application import db


class UserFamily(db.Model):
    __tablename__ = 'user_family'

    id = db.Column(db.Integer, primary_key=True)
    userid = db.Column(db.Integer)
    name=db.Column(db.String(30, 'utf8mb4_0900_ai_ci'))
    relationship = db.Column(db.String(30, 'utf8mb4_0900_ai_ci'))
    company = db.Column(db.String(30, 'utf8mb4_0900_ai_ci'))
    mobile= db.Column(db.String(30, 'utf8mb4_0900_ai_ci'))
    post = db.Column(db.String(30, 'utf8mb4_0900_ai_ci'))

    updated_time = db.Column(db.DateTime)
    created_time = db.Column(db.DateTime)

